package com.iwdnb.gkgz.common.constant;

public class SqlConstants {
    /**
     * 策略交易结果根据走势图形统计
     */
    public static final String STOCK_IMAGE_STATISTIC =
        "select CEILING(v39) imageCode,win_flag winFlag,count(1) count,sum(profit_rate) sum,"
            + "sum(profit_rate)/count(1) rate from gkgz_strategy_trade "
            + "where is_deleted='n' and uuid=:strategy and `status`='sell' "
            + "group by v39,win_flag";
}
